How to: Print a selection of a worksheet.
Solution:
Select the range of cells to print. Select 'Print...' from the 'File' menu and select the 'Selection' radio button in the 'Print What' group.
1) Select the range of cells to be printed.
2) Select the 'File' menu and select 'Print...'. (The Print dialog box appears.)
3) Select the printer to which to print the selection from the 'Name' drop-down list of the 'Printer' group.
4) Select the 'Selection' radio button in the 'Print What' group.
5) Select the 'All' radio button in the 'Page Range' group.
Specifying the printing options
6) (Optional) Type the desired number in the 'Number of copies' box.
NOTE: The number of copies always defaults to '1'. Type a different number if necessary.
7) Click 'OK'.